
*** OPEN LOG/OUTPUT FILE ***

log using "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\cooperativeagreements.UQFE.11-11-2020.MANUSCRIPT MODELS.smcl", replace





*** ALL COOPERATIVE AGREEMENTS [NEW AWARDS, CONTINUATION OF PREVIOUS AWARDS, & REVISIONS OF EXISTING AWARDS] ***


*** SUPPLEMENTARY ANALYSES INVOLVING BOTH AGENCY HEAD MANAGERIAL COMPETENCE & AGENCY STAFF TECHNICAL EXPERTISE CONDITIONAL EFFECTS BY PARTER ORGANIZATION TYPE [INCLUDING AGENCY HEAD POLICY EXPERTISE] *** 


**** ACCESS DATABASE ***

use "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Data\cooperativeagreements.grantlevel.11-06-2020.dta", replace



set matsize 10000



*** CREATE ANNUAL BINARY INDICATORS ***

gen year_88 = 1 if year_qtr_17==1 | year_qtr_18==1 | year_qtr_19==1 | year_qtr_20==1
replace year_88=0 if year_88==.
*
gen year_89 = 1 if year_qtr_21==1 | year_qtr_22==1 | year_qtr_23==1 | year_qtr_24==1
replace year_89 = 0 if year_89==.
*
gen year_90 = 1 if year_qtr_25==1 | year_qtr_26==1 | year_qtr_27==1 | year_qtr_28==1
replace year_90 = 0 if year_90==.
*
gen year_91 = 1 if year_qtr_29==1 | year_qtr_30==1 | year_qtr_31==1 | year_qtr_32==1
replace year_91 = 0 if year_91==.
*
gen year_92 = 1 if year_qtr_33==1 | year_qtr_34==1 | year_qtr_35==1 | year_qtr_36==1
replace year_92 = 0 if year_92==.
*
gen year_93 = 1 if year_qtr_37==1 | year_qtr_38==1 | year_qtr_39==1 | year_qtr_40==1
replace year_93 = 0 if year_93==.
*
gen year_94 = 1 if year_qtr_41==1 | year_qtr_42==1 | year_qtr_43==1 | year_qtr_44==1
replace year_94 = 0 if year_94==.
*
gen year_95 = 1 if year_qtr_45==1 | year_qtr_46==1 | year_qtr_47==1 | year_qtr_48==1
replace year_95 = 0 if year_95==.
*
gen year_96 = 1 if year_qtr_49==1 | year_qtr_50==1 | year_qtr_51==1 | year_qtr_52==1
replace year_96=0 if year_96==.
*
gen year_97 = 1 if year_qtr_53==1 | year_qtr_54==1 | year_qtr_55==1 | year_qtr_56==1
replace year_97 = 0 if year_97==.
*
gen year_98 = 1 if year_qtr_57==1 | year_qtr_58==1 | year_qtr_59==1 | year_qtr_60==1
replace year_98 = 0 if year_98==.
*
gen year_99 = 1 if year_qtr_61==1 | year_qtr_62==1 | year_qtr_63==1 | year_qtr_64==1
replace year_99 = 0 if year_99==.
*
gen year_00 = 1 if year_qtr_65==1 | year_qtr_66==1 | year_qtr_67==1 | year_qtr_68==1
replace year_00 = 0 if year_00==.
*
gen year_01 = 1 if year_qtr_69==1 | year_qtr_70==1 | year_qtr_71==1 | year_qtr_72==1
replace year_01 = 0 if year_01==.
*
gen year_02 = 1 if year_qtr_73==1 | year_qtr_74==1 | year_qtr_75==1 | year_qtr_76==1
replace year_02 = 0 if year_02==.
*
gen year_03 = 1 if year_qtr_77==1 | year_qtr_78==1 | year_qtr_79==1 | year_qtr_80==1
replace year_03 = 0 if year_03==.
*
gen year_04 = 1 if year_qtr_81==1 | year_qtr_82==1 | year_qtr_83==1 | year_qtr_84==1
replace year_04 = 0 if year_04==.
*
gen year_05 = 1 if year_qtr_85==1 | year_qtr_86==1 | year_qtr_87==1 | year_qtr_88==1
replace year_05 = 0 if year_05==.
*
gen year_06 = 1 if year_qtr_89==1 | year_qtr_90==1 | year_qtr_91==1 | year_qtr_92==1
replace year_06 = 0 if year_06==.
*
gen year_07 = 1 if year_qtr_93==1 | year_qtr_94==1 | year_qtr_95==1 | year_qtr_96==1
replace year_07 = 0 if year_07==.
*
gen year_08 = 1 if year_qtr_97==1 | year_qtr_98==1 | year_qtr_99==1 | year_qtr_100==1
replace year_08 = 0 if year_08==.




**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************






**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************




*** OBTAIN DESCRIPTIVE STATISTICS FOR RELEVANT COVARIATES TO COMPUTE POSITIVE INTERQUARTILE UNIT CHANGE ///
*** IN MANAGERIAL COMPETENCE [zmanage2_abszero] & AGENCY STAFF TECHNICAL EXPERTISE [perc_tech] BASED ON EFFECTIVE SAMPLE [N = 241,730] ***

quietly xtrifreg fed_funding   zpolicy2_abszero zmanage2_abszero ceo  privmgt  pctagency_packing perc_prof nongov_recip  ///
zloyalty2_abszero  electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  ceo  privmgt ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(05)
*
*
*

* AGENCY HEAD POLICY COMPETENCE INTERQUARTILE DIFFERENCE FOR EFFECTIVE SAMPLE PERIOD [FULL SAMPLE: N = 241,730] *
sum zpolicy2_abszero if e(sample), detail 
display  2.501583 - 1.452532
*
* AGENCY HEAD POLICY COMPETENCE INTERQUARTILE DIFFERENCE FOR EFFECTIVE SAMPLE PERIOD [GOVERNMENT SUBSAMPLE: N = 151,851] *
sum zpolicy2_abszero if e(sample) & nongov_recip==0, detail 
display  2.478046 - 1.452532
*
* AGENCY HEAD POLICY COMPETENCE INTERQUARTILE DIFFERENCE FOR EFFECTIVE SAMPLE PERIOD [NON-GOVERNMENT SUBSAMPLE: N = 89,879] *
sum zpolicy2_abszero if e(sample) & nongov_recip==1, detail 
display  2.501583 - 1.519779
*
* AGENCY HEAD POLICY COMPETENCE INTERQUARTILE DIFFERENCE FOR EFFECTIVE SAMPLE PERIOD [NON-PROFIT/NON-GOVERNMENT SUBSAMPLE: N = 44,333] *
sum zpolicy2_abszero if e(sample) & nonprofit_recip==1, detail 
display  2.320016 - 1.718157

* AGENCY HEAD POLICY COMPETENCE INTERQUARTILE DIFFERENCE FOR EFFECTIVE SAMPLE PERIOD [PRIVATE/NON-GOVERNMENT SUBSAMPLE: N = 45,546] *
sum zpolicy2_abszero if e(sample) & private_recip==1, detail 
display   2.807556 -  1.116298
*
*
*

* AGENCY HEAD MANAGERIAL COMPETENCE INTERQUARTILE DIFFERENCE FOR EFFECTIVE SAMPLE PERIOD *
* display 2.314321 -  1.12634

* AGENCY STAFF PROFESSIONALIM INTERQUARTILE DIFFERENCE FOR EFFECTIVE SAMPLE PERIOD *
* display 0.3981229 -  0.2582625  

 
 
 
*** I. MODEL 1.1: PROGRAM, SUBAGENCY, AND TIME FEs [WITH PROGRAM-CLUSTERED STANDARD ERRORS]: NON-GOVERNMENT PARTNER RECIPIENT ***



**** EVALUATE VARYING $-VALUED COOPERATIVE AGREEMENTS AT CONDITIONAL QUANTILES *****



** UNCONDITIONAL QUANTILE FIXED EFFECTS MODEL [Q = 0.05, 0.10, 0.25, 0.50, 0.75, 0.90, 0.95] **


**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************


* Q = 0.05 [$ 2,126.956: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zmanage2_abszero ceo  privmgt pctagency_packing perc_prof nongov_recip  ///
zloyalty2_abszero  electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt   year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 ///
year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, fe i(subagency) q(05)

estat ic


*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.05 ///

** ESTIMATES FOR FIGURE 4: Q = 0.05 **
lincom (zpolicy2_abszero*2.501583 - zpolicy2_abszero*1.452532) 
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  
 
* Q = 0.10 [$ 5,249.512: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zmanage2_abszero  ceo  privmgt  pctagency_packing perc_prof  nongov_recip ///
zloyalty2_abszero electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 ///
year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, fe i(subagency) q(10)

estat ic


*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.10 ///

** ESTIMATES FOR FIGURE 4: Q = 0.10 **
lincom (zpolicy2_abszero*2.501583 - zpolicy2_abszero*1.452532) 
*
*


**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  
 
  
* Q = 0.25 [$ 17,862.89: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zmanage2_abszero ceo  privmgt  pctagency_packing perc_prof  nongov_recip  ///
zloyalty2_abszero electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 ///
year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, fe i(subagency) q(25)

estat ic



*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.25 ///

** ESTIMATES FOR FIGURE 4: Q = 0.25 **
lincom (zpolicy2_abszero*2.501583 - zpolicy2_abszero*1.452532) 
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
   

   
* Q = 0.50 [$ 63,306.38: N = 241,730] *
xtrifreg fed_funding  zpolicy2_abszero zmanage2_abszero  ceo  privmgt pctagency_packing perc_prof  nongov_recip ///
zloyalty2_abszero electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 ///
year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, fe i(subagency) q(50)

estat ic



*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.50 ///

** ESTIMATES FOR FIGURE 4: Q = 0.50 [MEDIAN] **
lincom (zpolicy2_abszero*2.501583 - zpolicy2_abszero*1.452532) 
*
*




**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  

* Q = 0.75 [$ 233,762: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zmanage2_abszero  ceo  privmgt  pctagency_packing perc_prof  nongov_recip ///
zloyalty2_abszero electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 ///
year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, fe i(subagency) q(75)

estat ic


*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.75 ///

** ESTIMATES FOR FIGURE 4: Q = 0.75 **
lincom (zpolicy2_abszero*2.501583 - zpolicy2_abszero*1.452532) 
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  
  
* Q = 0.90 [$ 786,330.1: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zmanage2_abszero ceo  privmgt  pctagency_packing perc_prof  nongov_recip ///
zloyalty2_abszero electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 ///
year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, fe i(subagency) q(90)

estat ic



*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.90 ///

** ESTIMATES FOR FIGURE 4: Q = 0.90 **
lincom (zpolicy2_abszero*2.501583 - zpolicy2_abszero*1.452532) 
*




**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
   
   
 
* Q = 0.95 [$ 1,623,405: N = 241,730] *
xtrifreg fed_funding  zpolicy2_abszero zmanage2_abszero ceo  privmgt  pctagency_packing perc_prof  nongov_recip ///
zloyalty2_abszero electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 ///
year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, fe i(subagency) q(95)

estat ic


*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.95 ///

** ESTIMATES FOR FIGURE 4: Q = 0.95 **
lincom (zpolicy2_abszero*2.501583 - zpolicy2_abszero*1.452532) 
*




**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
   

** FOR REGRESSION COMPARISON PURPOSES ONLY **   
 
* E [LN (Y)]  LOGGED TRANSFORMED CONDITIONAL MEAN [OLS]: [UNTRANSFORMED: $ 408,215; LOGGED TRANSFORMED CONVERSION: $ 61,101: N = 241,730] *
regress ln_fed_funding  zpolicy2_abszero zmanage2_abszero   ceo  privmgt  pctagency_packing perc_prof  nongov_recip ///
zloyalty2_abszero electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  i.subagency ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 ///
year_06 year_07 year_08, vce(cluster subagency)

estat ic





**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************

 



*** CREATE RELEVANT INTERACTION TERMS FOR MANAGERIAL COMPETENCE AND AGENCY STAFF TECHNICAL EXPERTISE COVARIATES *** 
*** FIRST, CREATE EFFECTIVE SAMPLE PERIOD OF OBSERVATIONS TO ENSURE MATCH ACROSS MODELS ***

quietly xtrifreg fed_funding   zpolicy2_abszero zmanage2_abszero ceo privmgt zloyalty2_abszero nongov_recip pctagency_packing perc_prof  ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  /// 
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(05)


 
 

 
*** I. MODEL 1.2: PROGRAM, SUBAGENCY, AND TIME FEs [WITH PROGRAM-CLUSTERED STANDARD ERRORS]: INTERACTION BETWEEN POLICY EXPERTISE & NON-GOVERNMENT PARTNER RECIPIENT ***


*** CREATE NON-GOVERNMENT PARTNER/RECIPIENT INTERACTION COVARIATES [AGENCY HEAD POLICY EXPERTISE] ***

generate zpol2azng  = zpolicy2_abszero * nongov_recip
*



**** EVALUATE VARYING $-VALUED COOPERATIVE AGREEMENTS AT CONDITIONAL QUANTILES *****



** UNCONDITIONAL QUANTILE FIXED EFFECTS MODEL [Q = 0.05, 0.10, 0.25, 0.50, 0.75, 0.90, 0.95] **


**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************


* Q = 0.05 [$ 2,126.956: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zpol2azng zmanage2_abszero ceo privmgt pctagency_packing perc_prof nongov_recip zloyalty2_abszero ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt   ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(05)

estat ic


*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.05 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-GOVERNMENT PARTNER/RECIPIENT EFFECT APPEARS SECOND ****


** ESTIMATES FOR FIGURE 5A: Q = 0.05 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 
*
** ESTIMATES FOR FIGURE 5B: Q = 0.05 [NON-GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 + zpol2azng*2.501583 - zpolicy2_abszero*1.452532 - zpol2azng*1.519779)
*
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  
 
* Q = 0.10 [$ 5,249.512: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zpol2azng zmanage2_abszero ceo privmgt pctagency_packing perc_prof nongov_recip zloyalty2_abszero  ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(10)

estat ic




*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.10 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-GOVERNMENT PARTNER/RECIPIENT EFFECT APPEARS SECOND ****


** ESTIMATES FOR FIGURE 5A: Q = 0.10 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 
*
** ESTIMATES FOR FIGURE 5B: Q = 0.10 [NON-GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 + zpol2azng*2.501583 - zpolicy2_abszero*1.452532 - zpol2azng*1.519779)
*
*
*
*
*

**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  
 
  
* Q = 0.25 [$ 17,862.89: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zpol2azng zmanage2_abszero ceo privmgt pctagency_packing perc_prof nongov_recip zloyalty2_abszero ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt   ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(25)

estat ic




*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.25 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-GOVERNMENT PARTNER/RECIPIENT EFFECT APPEARS SECOND ****


** ESTIMATES FOR FIGURE 5A: Q = 0.25 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 
*
*
** ESTIMATES FOR FIGURE 5B: Q = 0.25 [NON-GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 + zpol2azng*2.501583 - zpolicy2_abszero*1.452532 - zpol2azng*1.519779)
*
*
*


**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
   

   
* Q = 0.50 [$ 63,306.38: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zpol2azng zmanage2_abszero ceo privmgt pctagency_packing perc_prof nongov_recip zloyalty2_abszero ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt   ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(50)

estat ic



*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.50 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-GOVERNMENT PARTNER/RECIPIENT EFFECT APPEARS SECOND ****


** ESTIMATES FOR FIGURE 5A: Q = 0.50 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 
*
** ESTIMATES FOR FIGURE 5B: Q = 0.50 [NON-GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 + zpol2azng*2.501583 - zpolicy2_abszero*1.452532 - zpol2azng*1.519779) 
*
*
*


**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  

* Q = 0.75 [$ 233,762: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zpol2azng zmanage2_abszero  ceo privmgt pctagency_packing perc_prof  nongov_recip zloyalty2_abszero   ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(75)

estat ic


*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.75 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-GOVERNMENT PARTNER/RECIPIENT EFFECT APPEARS SECOND ****


** ESTIMATES FOR FIGURE 5A: Q = 0.75 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 
*
** ESTIMATES FOR FIGURE 5B: Q = 0.75 [NON-GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 + zpol2azng*2.501583 - zpolicy2_abszero*1.452532 - zpol2azng*1.519779)
*
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  
  
* Q = 0.90 [$ 786,330.1: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zpol2azng zmanage2_abszero  ceo privmgt pctagency_packing perc_prof  nongov_recip zloyalty2_abszero   ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(90)

estat ic


*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.90 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-GOVERNMENT PARTNER/RECIPIENT EFFECT APPEARS SECOND ****


** ESTIMATES FOR FIGURE 5A: Q = 0.90 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 
*
** ESTIMATES FOR FIGURE 5B: Q = 0.90 [NON-GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 + zpol2azng*2.501583 - zpolicy2_abszero*1.452532 - zpol2azng*1.519779)
*
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
   
   
 
* Q = 0.95 [$ 1,623,405: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zpol2azng zmanage2_abszero  ceo privmgt pctagency_packing perc_prof  nongov_recip zloyalty2_abszero   ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(95)

estat ic


*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.95 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-GOVERNMENT PARTNER/RECIPIENT EFFECT APPEARS SECOND ****


** ESTIMATES FOR FIGURE 5A: Q = 0.95 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 
*
** ESTIMATES FOR FIGURE 5B: Q = 0.95 [NON-GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 + zpol2azng*2.501583 - zpolicy2_abszero*1.452532 - zpol2azng*1.519779)
*
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
   

** FOR REGRESSION COMPARISON PURPOSES ONLY **   
 
* E [LN (Y)] LOGGED TRANSFORMED CONDITIONAL MEAN [OLS]: [UNTRANSFORMED: $ 408,215; LOGGED TRANSFORMED CONVERSION: $ 61,101: N = 241,730] *
regress ln_fed_funding  zpolicy2_abszero zpol2azng zmanage2_abszero  ceo privmgt  pctagency_packing perc_prof  nongov_recip zloyalty2_abszero   ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  i.subagency year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 ///
year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, vce(cluster subagency) 


estat ic


**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************




 
*** I. MODEL 1.3: PROGRAM, SUBAGENCY, AND TIME FEs [WITH PROGRAM-CLUSTERED STANDARD ERRORS]: INTERACTIONS BETWEEN POLICY EXPERTISE ///
***               & NON-PROFIT AND PRVATE SECTOR RECIPIENTS ***



*** CREATE NON-PROFIT PARTNER/PRIVATE PARTNER RECIPIENT INTERACTION COVARIATES [AGENCY HEAD POLICY EXPERTISE] ***


generate zpol2aznp = zpolicy2_abszero * nonprofit_recip
*
generate zpol2azpriv = zpolicy2_abszero * private_recip
*
*
*




**** EVALUATE VARYING $-VALUED COOPERATIVE AGREEMENTS AT CONDITIONAL QUANTILES *****



** UNCONDITIONAL QUANTILE FIXED EFFECTS MODEL [Q = 0.05, 0.10, 0.25, 0.50, 0.75, 0.90, 0.95] **


**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************


* Q = 0.05 [$ 2,126.956: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zpol2aznp zpol2azpriv  zmanage2_abszero  ceo privmgt  pctagency_packing  perc_prof  nonprofit_recip private_recip zloyalty2_abszero  ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt   ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(05)

estat ic



*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.05 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-PROFIT PARTNER/RECIPIENT EFFECT APPEARS SECOND, ///
****      THE PRIVATE PARTNER/RECIPIENT APPEARS THIRD 


** ESTIMATES FOR FIGURE 6A: Q = 0.05 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 

** ESTIMATES FOR FIGURE 6B: Q = 0.05 [NON-PROFIT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2aznp*2.320016 - zpolicy2_abszero*1.452532 - zpol2aznp*1.718157)

** ESTIMATES FOR FIGURE 6C: Q = 0.05 [PRIVATE PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2azpriv*2.807556 - zpolicy2_abszero*1.452532 - zpol2azpriv*1.116298)

*
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  
 
* Q = 0.10 [$ 5,249.512: N = 241,730] *
xtrifreg fed_funding    zpolicy2_abszero zpol2aznp zpol2azpriv  zmanage2_abszero  ceo privmgt  pctagency_packing  perc_prof  nonprofit_recip private_recip zloyalty2_abszero  ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(10)

estat ic



*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.10 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-PROFIT PARTNER/RECIPIENT EFFECT APPEARS SECOND, ///
****      THE PRIVATE PARTNER/RECIPIENT APPEARS THIRD 


** ESTIMATES FOR FIGURE 6A: Q = 0.10 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 

** ESTIMATES FOR FIGURE 6B: Q = 0.10 [NON-PROFIT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2aznp*2.320016 - zpolicy2_abszero*1.452532 - zpol2aznp*1.718157)

** ESTIMATES FOR FIGURE 6C: Q = 0.10 [PRIVATE PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2azpriv*2.807556 - zpolicy2_abszero*1.452532 - zpol2azpriv*1.116298)

*
*
*


**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  
 
  
* Q = 0.25 [$ 17,862.89: N = 241,730] *
xtrifreg fed_funding    zpolicy2_abszero zpol2aznp zpol2azpriv  zmanage2_abszero  ceo privmgt  pctagency_packing  perc_prof  nonprofit_recip private_recip zloyalty2_abszero ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt   ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(25)

estat ic



*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.25 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-PROFIT PARTNER/RECIPIENT EFFECT APPEARS SECOND, ///
****      THE PRIVATE PARTNER/RECIPIENT APPEARS THIRD 


** ESTIMATES FOR FIGURE 6A: Q = 0.25 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 

** ESTIMATES FOR FIGURE 6B: Q = 0.25 [NON-PROFIT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2aznp*2.320016 - zpolicy2_abszero*1.452532 - zpol2aznp*1.718157)

** ESTIMATES FOR FIGURE 6C: Q = 0.25 [PRIVATE PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2azpriv*2.807556 - zpolicy2_abszero*1.452532 - zpol2azpriv*1.116298)


*
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
   

   
* Q = 0.50 [$ 63,306.38: N = 241,730] *
xtrifreg fed_funding    zpolicy2_abszero zpol2aznp zpol2azpriv  zmanage2_abszero  ceo privmgt  pctagency_packing  perc_prof  nonprofit_recip private_recip zloyalty2_abszero ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt   ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(50)

estat ic


*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.50 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-PROFIT PARTNER/RECIPIENT EFFECT APPEARS SECOND, ///
****      THE PRIVATE PARTNER/RECIPIENT APPEARS THIRD 


** ESTIMATES FOR FIGURE 6A: Q = 0.50 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 

** ESTIMATES FOR FIGURE 6B: Q = 0.50 [NON-PROFIT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2aznp*2.320016 - zpolicy2_abszero*1.452532 - zpol2aznp*1.718157)

** ESTIMATES FOR FIGURE 6C: Q = 0.50 [PRIVATE PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2azpriv*2.807556 - zpolicy2_abszero*1.452532 - zpol2azpriv*1.116298)

*
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  

* Q = 0.75 [$ 233,762: N = 241,730] *
xtrifreg fed_funding    zpolicy2_abszero zpol2aznp zpol2azpriv  zmanage2_abszero  ceo privmgt  pctagency_packing  perc_prof nonprofit_recip private_recip zloyalty2_abszero ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(75)

estat ic



*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.75 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-PROFIT PARTNER/RECIPIENT EFFECT APPEARS SECOND, ///
****      THE PRIVATE PARTNER/RECIPIENT APPEARS THIRD 


** ESTIMATES FOR FIGURE 6A: Q = 0.75 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 

** ESTIMATES FOR FIGURE 6B: Q = 0.75 [NON-PROFIT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2aznp*2.320016 - zpolicy2_abszero*1.452532 - zpol2aznp*1.718157)

** ESTIMATES FOR FIGURE 6C: Q = 0.75 [PRIVATE PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2azpriv*2.807556 - zpolicy2_abszero*1.452532 - zpol2azpriv*1.116298)

*
*
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
  
  
* Q = 0.90 [$ 786,330.1: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zpol2aznp zpol2azpriv  zmanage2_abszero  ceo privmgt  pctagency_packing  perc_prof  nonprofit_recip private_recip zloyalty2_abszero  ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(90)

estat ic




*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.90 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-PROFIT PARTNER/RECIPIENT EFFECT APPEARS SECOND, ///
****      THE PRIVATE PARTNER/RECIPIENT APPEARS THIRD 


** ESTIMATES FOR FIGURE 6A: Q = 0.90 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 

** ESTIMATES FOR FIGURE 6B: Q = 0.90 [NON-PROFIT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2aznp*2.320016 - zpolicy2_abszero*1.452532 - zpol2aznp*1.718157)

** ESTIMATES FOR FIGURE 6C: Q = 0.90 [PRIVATE PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2azpriv*2.807556 - zpolicy2_abszero*1.452532 - zpol2azpriv*1.116298)


*
*
*


**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
   
   
 
* Q = 0.95 [$ 1,623,405: N = 241,730] *
xtrifreg fed_funding   zpolicy2_abszero zpol2aznp zpol2azpriv  zmanage2_abszero  ceo privmgt  pctagency_packing  perc_prof  nonprofit_recip private_recip zloyalty2_abszero  ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(95)

estat ic



*** AVERAGE MARGINAL INTERQUARTILE RANGE EFFECTS OF KEY INTERACTION COVARIATES ON COOPERATIVE AGREEMENT SIZE [IN CONSTANT DOLLAR TERMS] AT Q = 0.95 ///


*** NOTE: GOVERNMENT PARTNER/RECIPIENT EFFECT IS THE BASELINE EFFECT APPEARING FIRST, THE TOTAL NON-PROFIT PARTNER/RECIPIENT EFFECT APPEARS SECOND, ///
****      THE PRIVATE PARTNER/RECIPIENT APPEARS THIRD 


** ESTIMATES FOR FIGURE 6A: Q = 0.95 [GOVERNMENT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046 - zpolicy2_abszero*1.452532) 

** ESTIMATES FOR FIGURE 6B: Q = 0.95 [NON-PROFIT PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2aznp*2.320016 - zpolicy2_abszero*1.452532 - zpol2aznp*1.718157)

** ESTIMATES FOR FIGURE 6C: Q = 0.95 [PRIVATE PARTNER/RECIPIENT] **
lincom (zpolicy2_abszero*2.478046  + zpol2azpriv*2.807556 - zpolicy2_abszero*1.452532 - zpol2azpriv*1.116298)

*
*
*



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
   

** FOR REGRESSION COMPARISON PURPOSES ONLY **   
 
* E [LN (Y)] LOGGED TRANSFORMED CONDITIONAL MEAN [OLS]: [UNTRANSFORMED: $ 408,215; LOGGED TRANSFORMED CONVERSION: $ 61,101: N = 241,730] *
regress ln_fed_funding  zpolicy2_abszero zpol2aznp zpol2azpriv  zmanage2_abszero  ceo privmgt  pctagency_packing  perc_prof  nonprofit_recip private_recip zloyalty2_abszero  ///
electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt  i.subagency year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 ///
year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, vce(cluster subagency) 


estat ic




**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************


save "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Data\cooperativeagreements.grantlevel.MANUSCRIPT MODELS.11-06-2020.dta", replace



   
log close
